
<?php

mysql_connect("localhost", "admin", "") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());

mysql_query("INSERT INTO artistgenre 
(aname,vname) VALUES('Sarah Brightman', 'classic') ") 
or die(mysql_error());

mysql_query("INSERT INTO artistgenre 
(aname,vname) VALUES('Britney Spears', 'pop') ") 
or die(mysql_error());

mysql_query("INSERT INTO artistgenre 
(aname,vname) VALUES('Bon Jovi', 'rock') ") 
or die(mysql_error());

mysql_query("INSERT INTO artistgenre 
(aname,vname) VALUES('John Denver', 'folk') ") 
or die(mysql_error());

mysql_query("INSERT INTO artistgenre 
(aname,vname) VALUES('Jason Mraz', 'folk') ") 
or die(mysql_error());

mysql_query("INSERT INTO artistgenre 
(aname,vname) VALUES('Jason Mraz', 'rock') ") 
or die(mysql_error());

mysql_query("INSERT INTO artistgenre 
(aname,vname) VALUES('Jason Mraz', 'pop') ") 
or die(mysql_error());


echo "Data Artistgenre Inserted!";
?>








<?php

mysql_connect("localhost", "admin", "") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());

mysql_query("INSERT INTO concerts 
(aname, vname, starttime, endtime, fee) VALUES('Sarah Brightman', 'Carnegie Hall','2000-7-4 18:00:00','2000-7-4 23:30:00','150.00')") 
or die(mysql_error()); 

mysql_query("INSERT INTO concerts 
(aname, vname, starttime, endtime, fee) VALUES('Sarah Brightman', 'Carnegie Hall','2012-6-20 18:00:00','2012-6-20 21:30:00','250.00')") 
or die(mysql_error()); 

mysql_query("INSERT INTO concerts 
(aname, vname, starttime, endtime, fee) VALUES('Sarah Brightman', 'Brooklyn Academy of Music','2012-7-1 18:00:00','2012-7-1 21:30:00','250.00')") 
or die(mysql_error()); 


mysql_query("INSERT INTO concerts 
(aname, vname, starttime, endtime, fee) VALUES('Sarah Brightman', 'New York City Center','2012-12-30 17:00:00','2012-12-30 23:30:00','260.00')") 
or die(mysql_error()); 

mysql_query("INSERT INTO concerts 
(aname, vname, starttime, endtime, fee) VALUES('Britney Spears', 'Carnegie Hall','2012-12-1 17:30:00','2012-12-1 23:30:00','300.00')") 
or die(mysql_error()); 

mysql_query("INSERT INTO concerts 
(aname, vname, starttime, endtime, fee) VALUES('Jason Mraz', 'Carnegie Hall','2012-10-3 20:00:00','2012-10-3 22:30:00','175.00')") 
or die(mysql_error()); 

mysql_query("INSERT INTO concerts 
(aname, vname, starttime, endtime, fee) VALUES('Britney Spears', 'Carnegie Hall','2012-10-3 20:00:00','2012-10-3 22:30:00','175.00')") 
or die(mysql_error()); 

echo "Data Concerts Inserted!";

?>













<?php

mysql_connect("localhost", "admin", "") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());

mysql_query("INSERT INTO venues 
(vname, address, phonenum) VALUES('Carnegie Hall', '881, Seventh Avenue, New York, NY','9136112123' ) ") 
or die(mysql_error()); 

mysql_query("INSERT INTO venues 
(vname, address, phonenum) VALUES('Coronado Theatre', '314, North Main Street, Rockford, IL','3156789006' ) ") 
or die(mysql_error()); 

mysql_query("INSERT INTO venues 
(vname, address, phonenum) VALUES('Boston Opera House', '538, Washington St. in Boston, MA','6172593400' ) ") 
or die(mysql_error());

mysql_query("INSERT INTO venues 
(vname, address, phonenum) VALUES('Brooklyn Academy of Music', '30, Lafayette Avenue, New York, NY','9175389000' ) ") 
or die(mysql_error());

mysql_query("INSERT INTO venues 
(vname, address, phonenum) VALUES('New York City Center', '130, 56th St, New York, NY','9145389111' ) ") 
or die(mysql_error());

echo "Data Inserted!";
?>





<?php
// Make a MySQL Connection
mysql_connect("localhost", "admin", "") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());

// Insert a row of information into the table "example"
mysql_query("INSERT INTO artists 
(aname, type) VALUES('Sarah Brightman', 'individual' ) ") 
or die(mysql_error());  

mysql_query("INSERT INTO artists 
(aname, type) VALUES('Britney Spears', 'individual' ) ") 
or die(mysql_error()); 

mysql_query("INSERT INTO artists 
(aname, type) VALUES('Bon Jovi', 'individual' ) ") 
or die(mysql_error()); 

mysql_query("INSERT INTO artists 
(aname, type) VALUES('John Denver', 'individual' ) ") 
or die(mysql_error()); 

mysql_query("INSERT INTO artists 
(aname, type) VALUES('Usher', 'individual' ) ") 
or die(mysql_error()); 

mysql_query("INSERT INTO artists 
(aname, type) VALUES('Beatles', 'group' ) ") 
or die(mysql_error()); 

mysql_query("INSERT INTO artists 
(aname, type) VALUES('Black Eyed Peas', 'group' ) ") 
or die(mysql_error()); 

mysql_query("INSERT INTO artists 
(aname, type) VALUES('Jason Mraz', 'individual' ) ") 
or die(mysql_error()); 


echo "Data Inserted!";

?>